using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VVRPOS
    {
        public void SetUpNewRow(ref DataRow dwReturn)
        {

            switch (app.company)
            {
                case "YGR":
                case "TST":
                default:
                    #region=========
                    dwReturn["VRPMANDANT"] = app.Mandant;
                    dwReturn["VRPRENR"] = "00000000";
                    dwReturn["VRPREPOS"] = "001";
                    dwReturn["VRPFILLER1"] = " ";
                    dwReturn["VRPAUFKRS"] = "  ";
                    dwReturn["VRPAUFLFD"] = "000000";
                    dwReturn["VRPAUFPOS"] = "000";
                    dwReturn["VRPLIEFSCH"] = "00000000";
                    dwReturn["VRPWAWERT"] = "0000000000";
                    dwReturn["VRPFRACHT"] = "0000000000";
                    dwReturn["VRPVERSICH"] = "0000000000";
                    dwReturn["VRPVERPKO"] = "0000000000";
                    dwReturn["VRPGESWERT"] = "0000000000";
                    dwReturn["VRPVERSART"] = "   ";
                    dwReturn["VRPSPED"] = "   ";
                    dwReturn["VRPVG"] = "RMB";
                    dwReturn["VRPRRENR"] = "00000000";
                    dwReturn["VRPRREPOS"] = "000";
                    dwReturn["VRPKOLL"] = "     ";
                    dwReturn["VRPART"] = "                        ";
                    dwReturn["VRPFARBE"] = "          ";
                    dwReturn["VRPZENSUR"] = "1";
                    dwReturn["VRPPRODST"] = "M";
                    dwReturn["VRPARTST"] = "F";
                    dwReturn["VRPMENGE"] = "100000";
                    dwReturn["VRPMENGET1"] = "0";
                    dwReturn["VRPMENGET2"] = "0";
                    dwReturn["VRPMENGET3"] = "0";
                    dwReturn["VRPMENGET4"] = "0";
                    dwReturn["VRPMEEH"] = "M  ";
                    dwReturn["VRPMEEHGRP"] = "2";
                    dwReturn["VRPMEEHFKT"] = "000001000000";
                    dwReturn["VRPFIXMASS"] = " ";
                    dwReturn["VRPANLBRT"] = "0";
                    dwReturn["VRPANLHOE"] = "0";
                    dwReturn["VRPPREIS"] = "0000000000";
                    dwReturn["VRPPREH"] = "M  ";
                    dwReturn["VRPPREHGRP"] = "2";
                    dwReturn["VRPPREHFKT"] = "000001000000";
                    dwReturn["VRPKONFEKT"] = "0";
                    dwReturn["VRPZUGET"] = "0";
                    dwReturn["VRPZUGETT1"] = "0";
                    dwReturn["VRPZUGETT2"] = "0";
                    dwReturn["VRPZUGETT3"] = "0";
                    dwReturn["VRPZUGETT4"] = "0";
                    dwReturn["VRPGRUND"] = "MA ";
                    dwReturn["VRPFSCHL"] = "   ";
                    dwReturn["VRPVLIEFNR"] = "        ";
                    dwReturn["VRPKSTKRS"] = "  ";
                    dwReturn["VRPKST"] = "0000";
                    dwReturn["VRPRABART1"] = "   ";
                    dwReturn["VRPRABPROZ1"] = "0";
                    dwReturn["VRPRABWERT1"] = "0";
                    dwReturn["VRPRABART2"] = "   ";
                    dwReturn["VRPRABPROZ2"] = "0";
                    dwReturn["VRPRABWERT2"] = "0";
                    dwReturn["VRPRABART3"] = "   ";
                    dwReturn["VRPRABPROZ3"] = "0";
                    dwReturn["VRPRABWERT3"] = "0";
                    dwReturn["VRPRABART4"] = "   ";
                    dwReturn["VRPRABPROZ4"] = "0";
                    dwReturn["VRPRABWERT4"] = "0";
                    dwReturn["VRPRABART5"] = "   ";
                    dwReturn["VRPRABPROZ5"] = "0";
                    dwReturn["VRPRABWERT5"] = "0";
                    dwReturn["VRPZUART1"] = "   ";
                    dwReturn["VRPZUABPROZ1"] = "0";
                    dwReturn["VRPZUABWERT1"] = "0";
                    dwReturn["VRPZUART2"] = "   ";
                    dwReturn["VRPZUABPROZ2"] = "0";
                    dwReturn["VRPZUABWERT2"] = "0";
                    dwReturn["VRPZUART3"] = "   ";
                    dwReturn["VRPZUABPROZ3"] = "0";
                    dwReturn["VRPZUABWERT3"] = "0";
                    dwReturn["VRPZUART4"] = "   ";
                    dwReturn["VRPZUABPROZ4"] = "0";
                    dwReturn["VRPZUABWERT4"] = "0";
                    dwReturn["VRPZUART5"] = "   ";
                    dwReturn["VRPZUABPROZ5"] = "0";
                    dwReturn["VRPZUABWERT5"] = "0";
                    dwReturn["VRPVERTNR1"] = "        ";
                    dwReturn["VRPPVBAS1"] = " ";
                    dwReturn["VRPPVVAR1"] = "0";
                    dwReturn["VRPPROVA1"] = "0";
                    dwReturn["VRPPROVP1"] = "0";
                    dwReturn["VRPPROVPFL1"] = " ";
                    dwReturn["VRPVERTNR2"] = "        ";
                    dwReturn["VRPPVBAS2"] = " ";
                    dwReturn["VRPPVVAR2"] = "0";
                    dwReturn["VRPPROVA2"] = "0";
                    dwReturn["VRPPROVP2"] = "0";
                    dwReturn["VRPPROVPFL2"] = " ";
                    dwReturn["VRPVERTNR3"] = "        ";
                    dwReturn["VRPPVBAS3"] = " ";
                    dwReturn["VRPPVVAR3"] = "0";
                    dwReturn["VRPPROVA3"] = "0";
                    dwReturn["VRPPROVP3"] = "0";
                    dwReturn["VRPPROVPFL3"] = " ";
                    dwReturn["VRPVERTNR4"] = "        ";
                    dwReturn["VRPPVBAS4"] = " ";
                    dwReturn["VRPPVVAR4"] = "0";
                    dwReturn["VRPPROVA4"] = "0";
                    dwReturn["VRPPROVP4"] = "0";
                    dwReturn["VRPPROVPFL4"] = " ";
                    dwReturn["VRPKDAUFTNR"] = "                    ";
                    dwReturn["VRPKDAUFDAT"] = "0";
                    dwReturn["VRPKDKONTR"] = "               ";
                    dwReturn["VRPTEILNR"] = "0";
                    dwReturn["VRPAPOS"] = "0";
                    dwReturn["VRPERLKZ"] = " ";
                    dwReturn["VRPFWARTGRA"] = "     ";
                    dwReturn["VRPERLKTO"] = "0";
                    dwReturn["VRPRWBRT"] = "0";
                    dwReturn["VRPVERSDAT"] = "0";
                    dwReturn["VRPIBRT"] = "0";
                    dwReturn["VRPPRMENGE"] = "100000";
                    dwReturn["VRPBERBASIS"] = " ";
                    dwReturn["VRPSTAFFEL"] = "0";
                    dwReturn["VRPSTAFFME"] = " ";
                    dwReturn["VRPWERT"] = "0000000000";
                    dwReturn["VRPAUFMSL"] = "  ";
                    dwReturn["VRPPACKTYP"] = "    ";
                    dwReturn["VRPANFART"] = "    ";
                    dwReturn["VRPANFPROZ"] = "0";
                    dwReturn["VRPANFWERT"] = "0";
                    dwReturn["VRPMRKMPROZ"] = "0";
                    dwReturn["VRPPOSTYP"] = " ";
                    dwReturn["VRPPOSBEZ"] = "                    ";
                    dwReturn["VRPGRUPPE"] = " ";
                    dwReturn["VRPDRZUSCHL"] = " ";
                    dwReturn["VRPLFMENGE"] = "100000";
                    dwReturn["VRPLFMENGET1"] = "0";
                    dwReturn["VRPLFMENGET2"] = "0";
                    dwReturn["VRPLFMENGET3"] = "0";
                    dwReturn["VRPLFMENGET4"] = "0";
                    dwReturn["VRPZUABWT1"] = "0";
                    dwReturn["VRPZUABMEEH1"] = "   ";
                    dwReturn["VRPZUABWT2"] = "0";
                    dwReturn["VRPZUABMEEH2"] = "   ";
                    dwReturn["VRPZUABWT3"] = "0";
                    dwReturn["VRPZUABMEEH3"] = "   ";
                    dwReturn["VRPZUABWT4"] = "0";
                    dwReturn["VRPZUABMEEH4"] = "   ";
                    dwReturn["VRPZUABWT5"] = "0";
                    dwReturn["VRPZUABMEEH5"] = "   ";
                    dwReturn["VRPRABEB1"] = " ";
                    dwReturn["VRPRABEB2"] = " ";
                    dwReturn["VRPRABEB3"] = " ";
                    dwReturn["VRPRABEB4"] = " ";
                    dwReturn["VRPRABEB5"] = " ";
                    dwReturn["VRPZUAEB1"] = " ";
                    dwReturn["VRPZUAEB2"] = " ";
                    dwReturn["VRPZUAEB3"] = " ";
                    dwReturn["VRPZUAEB4"] = " ";
                    dwReturn["VRPZUAEB5"] = " ";
                    dwReturn["VRPANZPROD"] = "0";
                    dwReturn["VRPFIXBONP"] = "0";
                    dwReturn["VRPFIXBONA"] = "0";
                    dwReturn["VRPBONAEND"] = " ";
                    dwReturn["VRPBONKZ"] = "N";
                    dwReturn["VRPKSTTKZ"] = " ";
                    dwReturn["VRPURAUFKRS"] = "  ";
                    dwReturn["VRPURAUFLFD"] = "000000";
                    dwReturn["VRPURAUFPOS"] = "000";
                    dwReturn["VRPCOLORIT"] = "          ";
                    dwReturn["VRPDESSIN"] = "          ";
                    dwReturn["VRPBESCHICH"] = "          ";
                    dwReturn["VRPABPVAR"] = "   ";
                    dwReturn["VRPMINGRD"] = "   ";
                    dwReturn["VRPANLIEF"] = "0";
                    dwReturn["VRPMEEHFB"] = "0";
                    dwReturn["VRPARTKUNDNR"] = "        ";
                    dwReturn["VRPTERMNR"] = "0";
                    dwReturn["VRPWAEHRSL"] = "RMB";
                    dwReturn["VRPKURS"] = "10000";
                    dwReturn["VRPBETRAG"] = "1";
                    dwReturn["VRPGROE"] = "       ";
                    dwReturn["VRPNRKR"] = "  ";
                    dwReturn["VRPLFDNR"] = "000000";
                    dwReturn["VRPDATPRUEF"] = " ";
                    dwReturn["VRPSTORNO"] = " ";
                    dwReturn["VRPHWAEHRSL"] = "RMB";
                    dwReturn["VRPHEUROKURS"] = "0";
                    dwReturn["VRPHEUROKURSVK"] = " ";
                    dwReturn["VRPFEUROKURS"] = "0";
                    dwReturn["VRPFEUROKURSVK"] = " ";
                    dwReturn["VRPSTASCHL"] = "                 ";
                    dwReturn["VRPSTPROVP"] = "0";
                    dwReturn["VRPSTPROVAB"] = "0";
                    dwReturn["VRPSTFRACHT"] = "0";
                    dwReturn["VRPSTFRACHTAB"] = "0";
                    dwReturn["VRPSTFRME"] = "   ";
                    dwReturn["VRPSTIMP"] = "0";
                    dwReturn["VRPSTVERSP"] = "0";
                    dwReturn["VRPSTVERSAB"] = "0";
                    dwReturn["VRPDUTY"] = "0";
                    dwReturn["VRPSTZOLLP"] = "0";
                    dwReturn["VRPSTZOLLAB"] = "0";
                    dwReturn["VRPFOB"] = "0";
                    dwReturn["VRPFRGR"] = "0";
                    dwReturn["VRPFRGRME"] = "   ";
                    dwReturn["VRPFRGRAB"] = "0";
                    dwReturn["VRPVERSGR"] = "0";
                    dwReturn["VRPVERSGRAB"] = "0";
                    dwReturn["VRPROHWERT"] = "0";
                    dwReturn["VRPROHWERTAB"] = "0";
                    dwReturn["VRPCOBORDER"] = "0";
                    dwReturn["VRPZOLLTNR"] = "                    ";
                    dwReturn["VRPURLAND"] = "   ";
                    dwReturn["VRPPRFBEG"] = " ";
                    dwReturn["VRPPRFSCHL"] = "         ";
                    dwReturn["VRPLGERKLNR"] = "0";
                    dwReturn["VRPURZEUGKZ"] = " ";
                    dwReturn["VRPVERZKZ"] = " ";
                    dwReturn["VRPZOLAGER"] = "          ";
                    dwReturn["VRPEZOLLTNR"] = "                    ";
                    dwReturn["VRPZFORMNR"] = "          ";
                    dwReturn["VRPZFORMDAT"] = "0";
                    dwReturn["VRPAVVME"] = " ";
                    dwReturn["VRPUEBKZ"] = " ";
                    dwReturn["VRPZOLLANM"] = " ";
                    dwReturn["VRPSTATIST"] = " ";
                    dwReturn["VRPPRURLAND"] = "   ";
                    dwReturn["VRPVGBETRAG"] = "0";
                    dwReturn["VRPIPFRACHT"] = "0000000000";
                    dwReturn["VRPIPVERSICH"] = "0000000000";
                    dwReturn["VRPIPVERPKO"] = "0000000000";
                    dwReturn["VRPIPZOLL"] = "0000000000";
                    dwReturn["VRPIPIMP"] = "0000000000";
                    dwReturn["VRPAELFDNRO"] = "0";
                    dwReturn["VRPAELFDNRE"] = "0";
                    dwReturn["VRPAEDATUM"] = "0";
                    dwReturn["VRPNEMENGE"] = "0";
                    dwReturn["VRPNEMENGET1"] = "0";
                    dwReturn["VRPNEMENGET2"] = "0";
                    dwReturn["VRPNEMENGET3"] = "0";
                    dwReturn["VRPNEMENGET4"] = "0";
                    dwReturn["VRPFAKMEKZ"] = " ";
                    dwReturn["VRPZUABKZ1"] = " ";
                    dwReturn["VRPZUABKZ2"] = " ";
                    dwReturn["VRPZUABKZ3"] = " ";
                    dwReturn["VRPZUABKZ4"] = " ";
                    dwReturn["VRPZUABKZ5"] = " ";
                    dwReturn["VRPZUABMG1"] = "0";
                    dwReturn["VRPZUABMG2"] = "0";
                    dwReturn["VRPZUABMG3"] = "0";
                    dwReturn["VRPZUABMG4"] = "0";
                    dwReturn["VRPZUABMG5"] = "0";
                    dwReturn["VRPPROGRP"] = "NZ ";
                    dwReturn["VRPARTGRP"] = "   ";
                    dwReturn["VRPBUSIMODE"] = "DRE";
                    dwReturn["VRPINTRA"] = " ";
                    dwReturn["VRPAPOSTYP"] = "   ";
                    dwReturn["VRPNIXVV"] = " ";
                    dwReturn["VRPVERSLO"] = "  ";
                    dwReturn["VRPEMPLAND"] = "   ";
                    dwReturn["VRPWOHER1"] = " ";
                    dwReturn["VRPANTEIL1"] = "0";
                    dwReturn["VRPWOHER2"] = " ";
                    dwReturn["VRPANTEIL2"] = "0";
                    dwReturn["VRPWOHER3"] = " ";
                    dwReturn["VRPANTEIL3"] = "0";
                    dwReturn["VRPWOHER4"] = " ";
                    dwReturn["VRPANTEIL4"] = "0";
                    dwReturn["VRPANTSUMME"] = "00";
                    dwReturn["VRPVRFM06"] = "        ";
                    dwReturn["VRPAFOLGE"] = "000";
                    dwReturn["VRPWEBER"] = "        ";
                    dwReturn["VRPDRVERT"] = "                    ";
                    dwReturn["VRPCBOOKNO"] = "               ";
                    dwReturn["VRPCITEMNO"] = "0";
                    dwReturn["VRPZUSTAND"] = "    ";
                    dwReturn["VRPPACKANZ"] = "0";
                    dwReturn["VRPBRTGEW"] = "0";
                    dwReturn["VRPFILLER4"] = "          N                                                                                                                                                ";
                    dwReturn["VRPAENZL"] = "1";
                    dwReturn["VRPAENB"] = "        ";
                    dwReturn["VRPAEND"] = "0";
                    dwReturn["VRPNEUB"] = "        ";
                    dwReturn["VRPNEUD"] = "0";
                    #endregion
                    break;
                case "JLT":
                    #region=========
                    dwReturn["VRPMANDANT"] = app.Mandant;
                    dwReturn["VRPRENR"] = "00000000";
                    dwReturn["VRPREPOS"] = "001";
                    dwReturn["VRPFILLER1"] = " ";
                    dwReturn["VRPAUFKRS"] = "  ";
                    dwReturn["VRPAUFLFD"] = "000000";
                    dwReturn["VRPAUFPOS"] = "000";
                    dwReturn["VRPLIEFSCH"] = "00000000";
                    dwReturn["VRPWAWERT"] = "0000000000";
                    dwReturn["VRPFRACHT"] = "0000000000";
                    dwReturn["VRPVERSICH"] = "0000000000";
                    dwReturn["VRPVERPKO"] = "0000000000";
                    dwReturn["VRPGESWERT"] = "0000000000";
                    dwReturn["VRPVERSART"] = "   ";
                    dwReturn["VRPSPED"] = "   ";
                    dwReturn["VRPVG"] = "RMB";
                    dwReturn["VRPRRENR"] = "00000000";
                    dwReturn["VRPRREPOS"] = "000";
                    dwReturn["VRPKOLL"] = "     ";
                    dwReturn["VRPART"] = "                        ";
                    dwReturn["VRPFARBE"] = "          ";
                    dwReturn["VRPZENSUR"] = "1";
                    dwReturn["VRPPRODST"] = "M";
                    dwReturn["VRPARTST"] = "F";
                    dwReturn["VRPMENGE"] = "100000";
                    dwReturn["VRPMENGET1"] = "0";
                    dwReturn["VRPMENGET2"] = "0";
                    dwReturn["VRPMENGET3"] = "0";
                    dwReturn["VRPMENGET4"] = "0";
                    dwReturn["VRPMEEH"] = "M  ";
                    dwReturn["VRPMEEHGRP"] = "2";
                    dwReturn["VRPMEEHFKT"] = "000001000000";
                    dwReturn["VRPFIXMASS"] = " ";
                    dwReturn["VRPANLBRT"] = "0";
                    dwReturn["VRPANLHOE"] = "0";
                    dwReturn["VRPPREIS"] = "0000000000";
                    dwReturn["VRPPREH"] = "M  ";
                    dwReturn["VRPPREHGRP"] = "2";
                    dwReturn["VRPPREHFKT"] = "000001000000";
                    dwReturn["VRPKONFEKT"] = "0";
                    dwReturn["VRPZUGET"] = "0";
                    dwReturn["VRPZUGETT1"] = "0";
                    dwReturn["VRPZUGETT2"] = "0";
                    dwReturn["VRPZUGETT3"] = "0";
                    dwReturn["VRPZUGETT4"] = "0";
                    dwReturn["VRPGRUND"] = "MA ";
                    dwReturn["VRPFSCHL"] = "   ";
                    dwReturn["VRPVLIEFNR"] = "        ";
                    dwReturn["VRPKSTKRS"] = "  ";
                    dwReturn["VRPKST"] = "0000";
                    dwReturn["VRPRABART1"] = "   ";
                    dwReturn["VRPRABPROZ1"] = "0";
                    dwReturn["VRPRABWERT1"] = "0";
                    dwReturn["VRPRABART2"] = "   ";
                    dwReturn["VRPRABPROZ2"] = "0";
                    dwReturn["VRPRABWERT2"] = "0";
                    dwReturn["VRPRABART3"] = "   ";
                    dwReturn["VRPRABPROZ3"] = "0";
                    dwReturn["VRPRABWERT3"] = "0";
                    dwReturn["VRPRABART4"] = "   ";
                    dwReturn["VRPRABPROZ4"] = "0";
                    dwReturn["VRPRABWERT4"] = "0";
                    dwReturn["VRPRABART5"] = "   ";
                    dwReturn["VRPRABPROZ5"] = "0";
                    dwReturn["VRPRABWERT5"] = "0";
                    dwReturn["VRPZUART1"] = "   ";
                    dwReturn["VRPZUABPROZ1"] = "0";
                    dwReturn["VRPZUABWERT1"] = "0";
                    dwReturn["VRPZUART2"] = "   ";
                    dwReturn["VRPZUABPROZ2"] = "0";
                    dwReturn["VRPZUABWERT2"] = "0";
                    dwReturn["VRPZUART3"] = "   ";
                    dwReturn["VRPZUABPROZ3"] = "0";
                    dwReturn["VRPZUABWERT3"] = "0";
                    dwReturn["VRPZUART4"] = "   ";
                    dwReturn["VRPZUABPROZ4"] = "0";
                    dwReturn["VRPZUABWERT4"] = "0";
                    dwReturn["VRPZUART5"] = "   ";
                    dwReturn["VRPZUABPROZ5"] = "0";
                    dwReturn["VRPZUABWERT5"] = "0";
                    dwReturn["VRPVERTNR1"] = "        ";
                    dwReturn["VRPPVBAS1"] = " ";
                    dwReturn["VRPPVVAR1"] = "0";
                    dwReturn["VRPPROVA1"] = "0";
                    dwReturn["VRPPROVP1"] = "0";
                    dwReturn["VRPPROVPFL1"] = " ";
                    dwReturn["VRPVERTNR2"] = "        ";
                    dwReturn["VRPPVBAS2"] = " ";
                    dwReturn["VRPPVVAR2"] = "0";
                    dwReturn["VRPPROVA2"] = "0";
                    dwReturn["VRPPROVP2"] = "0";
                    dwReturn["VRPPROVPFL2"] = " ";
                    dwReturn["VRPVERTNR3"] = "        ";
                    dwReturn["VRPPVBAS3"] = " ";
                    dwReturn["VRPPVVAR3"] = "0";
                    dwReturn["VRPPROVA3"] = "0";
                    dwReturn["VRPPROVP3"] = "0";
                    dwReturn["VRPPROVPFL3"] = " ";
                    dwReturn["VRPVERTNR4"] = "        ";
                    dwReturn["VRPPVBAS4"] = " ";
                    dwReturn["VRPPVVAR4"] = "0";
                    dwReturn["VRPPROVA4"] = "0";
                    dwReturn["VRPPROVP4"] = "0";
                    dwReturn["VRPPROVPFL4"] = " ";
                    dwReturn["VRPKDAUFTNR"] = "                    ";
                    dwReturn["VRPKDAUFDAT"] = "0";
                    dwReturn["VRPKDKONTR"] = "               ";
                    dwReturn["VRPTEILNR"] = "0";
                    dwReturn["VRPAPOS"] = "0";
                    dwReturn["VRPERLKZ"] = " ";
                    dwReturn["VRPFWARTGRA"] = "     ";
                    dwReturn["VRPERLKTO"] = "0";
                    dwReturn["VRPRWBRT"] = "0";
                    dwReturn["VRPVERSDAT"] = "0";
                    dwReturn["VRPIBRT"] = "0";
                    dwReturn["VRPPRMENGE"] = "100000";
                    dwReturn["VRPBERBASIS"] = " ";
                    dwReturn["VRPSTAFFEL"] = "0";
                    dwReturn["VRPSTAFFME"] = " ";
                    dwReturn["VRPWERT"] = "0000000000";
                    dwReturn["VRPAUFMSL"] = "  ";
                    dwReturn["VRPPACKTYP"] = "    ";
                    dwReturn["VRPANFART"] = "    ";
                    dwReturn["VRPANFPROZ"] = "0";
                    dwReturn["VRPANFWERT"] = "0";
                    dwReturn["VRPMRKMPROZ"] = "0";
                    dwReturn["VRPPOSTYP"] = " ";
                    dwReturn["VRPPOSBEZ"] = "                    ";
                    dwReturn["VRPGRUPPE"] = " ";
                    dwReturn["VRPDRZUSCHL"] = " ";
                    dwReturn["VRPLFMENGE"] = "100000";
                    dwReturn["VRPLFMENGET1"] = "0";
                    dwReturn["VRPLFMENGET2"] = "0";
                    dwReturn["VRPLFMENGET3"] = "0";
                    dwReturn["VRPLFMENGET4"] = "0";
                    dwReturn["VRPZUABWT1"] = "0";
                    dwReturn["VRPZUABMEEH1"] = "   ";
                    dwReturn["VRPZUABWT2"] = "0";
                    dwReturn["VRPZUABMEEH2"] = "   ";
                    dwReturn["VRPZUABWT3"] = "0";
                    dwReturn["VRPZUABMEEH3"] = "   ";
                    dwReturn["VRPZUABWT4"] = "0";
                    dwReturn["VRPZUABMEEH4"] = "   ";
                    dwReturn["VRPZUABWT5"] = "0";
                    dwReturn["VRPZUABMEEH5"] = "   ";
                    dwReturn["VRPRABEB1"] = " ";
                    dwReturn["VRPRABEB2"] = " ";
                    dwReturn["VRPRABEB3"] = " ";
                    dwReturn["VRPRABEB4"] = " ";
                    dwReturn["VRPRABEB5"] = " ";
                    dwReturn["VRPZUAEB1"] = " ";
                    dwReturn["VRPZUAEB2"] = " ";
                    dwReturn["VRPZUAEB3"] = " ";
                    dwReturn["VRPZUAEB4"] = " ";
                    dwReturn["VRPZUAEB5"] = " ";
                    dwReturn["VRPANZPROD"] = "0";
                    dwReturn["VRPFIXBONP"] = "0";
                    dwReturn["VRPFIXBONA"] = "0";
                    dwReturn["VRPBONAEND"] = " ";
                    dwReturn["VRPBONKZ"] = "N";
                    dwReturn["VRPKSTTKZ"] = " ";
                    dwReturn["VRPURAUFKRS"] = "  ";
                    dwReturn["VRPURAUFLFD"] = "000000";
                    dwReturn["VRPURAUFPOS"] = "000";
                    dwReturn["VRPCOLORIT"] = "          ";
                    dwReturn["VRPDESSIN"] = "          ";
                    dwReturn["VRPBESCHICH"] = "          ";
                    dwReturn["VRPABPVAR"] = "   ";
                    dwReturn["VRPMINGRD"] = "   ";
                    dwReturn["VRPANLIEF"] = "0";
                    dwReturn["VRPMEEHFB"] = "0";
                    dwReturn["VRPARTKUNDNR"] = "        ";
                    dwReturn["VRPTERMNR"] = "0";
                    dwReturn["VRPWAEHRSL"] = "RMB";
                    dwReturn["VRPKURS"] = "10000";
                    dwReturn["VRPBETRAG"] = "1";
                    dwReturn["VRPGROE"] = "       ";
                    dwReturn["VRPNRKR"] = "  ";
                    dwReturn["VRPLFDNR"] = "000000";
                    dwReturn["VRPDATPRUEF"] = " ";
                    dwReturn["VRPSTORNO"] = " ";
                    dwReturn["VRPHWAEHRSL"] = "RMB";
                    dwReturn["VRPHEUROKURS"] = "0";
                    dwReturn["VRPHEUROKURSVK"] = " ";
                    dwReturn["VRPFEUROKURS"] = "0";
                    dwReturn["VRPFEUROKURSVK"] = " ";
                    dwReturn["VRPSTASCHL"] = "                 ";
                    dwReturn["VRPSTPROVP"] = "0";
                    dwReturn["VRPSTPROVAB"] = "0";
                    dwReturn["VRPSTFRACHT"] = "0";
                    dwReturn["VRPSTFRACHTAB"] = "0";
                    dwReturn["VRPSTFRME"] = "   ";
                    dwReturn["VRPSTIMP"] = "0";
                    dwReturn["VRPSTVERSP"] = "0";
                    dwReturn["VRPSTVERSAB"] = "0";
                    dwReturn["VRPDUTY"] = "0";
                    dwReturn["VRPSTZOLLP"] = "0";
                    dwReturn["VRPSTZOLLAB"] = "0";
                    dwReturn["VRPFOB"] = "0";
                    dwReturn["VRPFRGR"] = "0";
                    dwReturn["VRPFRGRME"] = "   ";
                    dwReturn["VRPFRGRAB"] = "0";
                    dwReturn["VRPVERSGR"] = "0";
                    dwReturn["VRPVERSGRAB"] = "0";
                    dwReturn["VRPROHWERT"] = "0";
                    dwReturn["VRPROHWERTAB"] = "0";
                    dwReturn["VRPCOBORDER"] = "0";
                    dwReturn["VRPZOLLTNR"] = "                    ";
                    dwReturn["VRPURLAND"] = "   ";
                    dwReturn["VRPPRFBEG"] = " ";
                    dwReturn["VRPPRFSCHL"] = "         ";
                    dwReturn["VRPLGERKLNR"] = "0";
                    dwReturn["VRPURZEUGKZ"] = " ";
                    dwReturn["VRPVERZKZ"] = " ";
                    dwReturn["VRPZOLAGER"] = "          ";
                    dwReturn["VRPEZOLLTNR"] = "                    ";
                    dwReturn["VRPZFORMNR"] = "          ";
                    dwReturn["VRPZFORMDAT"] = "0";
                    dwReturn["VRPAVVME"] = " ";
                    dwReturn["VRPUEBKZ"] = " ";
                    dwReturn["VRPZOLLANM"] = " ";
                    dwReturn["VRPSTATIST"] = " ";
                    dwReturn["VRPPRURLAND"] = "   ";
                    dwReturn["VRPVGBETRAG"] = "0";
                    dwReturn["VRPIPFRACHT"] = "0000000000";
                    dwReturn["VRPIPVERSICH"] = "0000000000";
                    dwReturn["VRPIPVERPKO"] = "0000000000";
                    dwReturn["VRPIPZOLL"] = "0000000000";
                    dwReturn["VRPIPIMP"] = "0000000000";
                    dwReturn["VRPAELFDNRO"] = "0";
                    dwReturn["VRPAELFDNRE"] = "0";
                    dwReturn["VRPAEDATUM"] = "0";
                    dwReturn["VRPNEMENGE"] = "0";
                    dwReturn["VRPNEMENGET1"] = "0";
                    dwReturn["VRPNEMENGET2"] = "0";
                    dwReturn["VRPNEMENGET3"] = "0";
                    dwReturn["VRPNEMENGET4"] = "0";
                    dwReturn["VRPFAKMEKZ"] = " ";
                    dwReturn["VRPZUABKZ1"] = " ";
                    dwReturn["VRPZUABKZ2"] = " ";
                    dwReturn["VRPZUABKZ3"] = " ";
                    dwReturn["VRPZUABKZ4"] = " ";
                    dwReturn["VRPZUABKZ5"] = " ";
                    dwReturn["VRPZUABMG1"] = "0";
                    dwReturn["VRPZUABMG2"] = "0";
                    dwReturn["VRPZUABMG3"] = "0";
                    dwReturn["VRPZUABMG4"] = "0";
                    dwReturn["VRPZUABMG5"] = "0";
                    dwReturn["VRPPROGRP"] = "NZ ";
                    dwReturn["VRPARTGRP"] = "   ";
                    dwReturn["VRPBUSIMODE"] = "DRE";
                    dwReturn["VRPINTRA"] = " ";
                    dwReturn["VRPAPOSTYP"] = "   ";
                    dwReturn["VRPNIXVV"] = " ";
                    dwReturn["VRPVERSLO"] = "  ";
                    dwReturn["VRPEMPLAND"] = "   ";
                    dwReturn["VRPWOHER1"] = " ";
                    dwReturn["VRPANTEIL1"] = "0";
                    dwReturn["VRPWOHER2"] = " ";
                    dwReturn["VRPANTEIL2"] = "0";
                    dwReturn["VRPWOHER3"] = " ";
                    dwReturn["VRPANTEIL3"] = "0";
                    dwReturn["VRPWOHER4"] = " ";
                    dwReturn["VRPANTEIL4"] = "0";
                    dwReturn["VRPANTSUMME"] = "00";
                    dwReturn["VRPVRFM06"] = "        ";
                    dwReturn["VRPAFOLGE"] = "000";
                    dwReturn["VRPWEBER"] = "        ";
                    dwReturn["VRPDRVERT"] = "                    ";
                    dwReturn["VRPCBOOKNO"] = "               ";
                    dwReturn["VRPCITEMNO"] = "0";
                    dwReturn["VRPZUSTAND"] = "    ";
                    dwReturn["VRPPACKANZ"] = "0";
                    dwReturn["VRPBRTGEW"] = "0";
                    dwReturn["VRPFILLER4"] = "          N                                                                                                                                                ";
                    dwReturn["VRPAENZL"] = "1";
                    dwReturn["VRPAENB"] = "        ";
                    dwReturn["VRPAEND"] = "0";
                    dwReturn["VRPNEUB"] = "        ";
                    dwReturn["VRPNEUD"] = "0";
                    #endregion
                    break;
            }
        }

        public void InsertVRPOS(DataRow dwData, string ITXDBVERSION = "50.24")
        {

            dwData["VRPNEUB"] = app.User;
            dwData["VRPNEUD"] = date;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                default:
                case "YGR":
                case "TST":
                    or1.CommandText = "INSERT INTO VRPOS ( VRPMANDANT,VRPRENR,VRPREPOS,VRPFILLER1,VRPAUFKRS,VRPAUFLFD,VRPAUFPOS,VRPLIEFSCH,VRPWAWERT,VRPFRACHT,VRPVERSICH,VRPVERPKO,VRPGESWERT,VRPVERSART,VRPSPED,VRPVG,VRPRRENR,VRPRREPOS,VRPKOLL,VRPART,VRPFARBE,VRPZENSUR,VRPPRODST,VRPARTST,VRPMENGE,VRPMENGET1,VRPMENGET2,VRPMENGET3,VRPMENGET4,VRPMEEH,VRPMEEHGRP,VRPMEEHFKT,VRPFIXMASS,VRPANLBRT,VRPANLHOE,VRPPREIS,VRPPREH,VRPPREHGRP,VRPPREHFKT,VRPKONFEKT,VRPZUGET,VRPZUGETT1,VRPZUGETT2,VRPZUGETT3,VRPZUGETT4,VRPGRUND,VRPFSCHL,VRPVLIEFNR,VRPKSTKRS,VRPKST,VRPRABART1,VRPRABPROZ1,VRPRABWERT1,VRPRABART2,VRPRABPROZ2,VRPRABWERT2,VRPRABART3,VRPRABPROZ3,VRPRABWERT3,VRPRABART4,VRPRABPROZ4,VRPRABWERT4,VRPRABART5,VRPRABPROZ5,VRPRABWERT5,VRPZUART1,VRPZUABPROZ1,VRPZUABWERT1,VRPZUART2,VRPZUABPROZ2,VRPZUABWERT2,VRPZUART3,VRPZUABPROZ3,VRPZUABWERT3,VRPZUART4,VRPZUABPROZ4,VRPZUABWERT4,VRPZUART5,VRPZUABPROZ5,VRPZUABWERT5,VRPVERTNR1,VRPPVBAS1,VRPPVVAR1,VRPPROVA1,VRPPROVP1,VRPPROVPFL1,VRPVERTNR2,VRPPVBAS2,VRPPVVAR2,VRPPROVA2,VRPPROVP2,VRPPROVPFL2,VRPVERTNR3,VRPPVBAS3,VRPPVVAR3,VRPPROVA3,VRPPROVP3,VRPPROVPFL3,VRPVERTNR4,VRPPVBAS4,VRPPVVAR4,VRPPROVA4,VRPPROVP4,VRPPROVPFL4,VRPKDAUFTNR,VRPKDAUFDAT,VRPKDKONTR,VRPTEILNR,VRPAPOS,VRPERLKZ,VRPFWARTGRA,VRPERLKTO,VRPRWBRT,VRPVERSDAT,VRPIBRT,VRPPRMENGE,VRPBERBASIS,VRPSTAFFEL,VRPSTAFFME,VRPWERT,VRPAUFMSL,VRPPACKTYP,VRPANFART,VRPANFPROZ,VRPANFWERT,VRPMRKMPROZ,VRPPOSTYP,VRPPOSBEZ,VRPGRUPPE,VRPDRZUSCHL,VRPLFMENGE,VRPLFMENGET1,VRPLFMENGET2,VRPLFMENGET3,VRPLFMENGET4,VRPZUABWT1,VRPZUABMEEH1,VRPZUABWT2,VRPZUABMEEH2,VRPZUABWT3,VRPZUABMEEH3,VRPZUABWT4,VRPZUABMEEH4,VRPZUABWT5,VRPZUABMEEH5,VRPRABEB1,VRPRABEB2,VRPRABEB3,VRPRABEB4,VRPRABEB5,VRPZUAEB1,VRPZUAEB2,VRPZUAEB3,VRPZUAEB4,VRPZUAEB5,VRPANZPROD,VRPFIXBONP,VRPFIXBONA,VRPBONAEND,VRPBONKZ,VRPKSTTKZ,VRPURAUFKRS,VRPURAUFLFD,VRPURAUFPOS,VRPCOLORIT,VRPDESSIN,VRPBESCHICH,VRPABPVAR,VRPMINGRD,VRPANLIEF,VRPMEEHFB,VRPARTKUNDNR,VRPTERMNR,VRPWAEHRSL,VRPKURS,VRPBETRAG,VRPGROE,VRPNRKR,VRPLFDNR,VRPDATPRUEF,VRPSTORNO,VRPHWAEHRSL,VRPHEUROKURS,VRPHEUROKURSVK,VRPFEUROKURS,VRPFEUROKURSVK,VRPSTASCHL,VRPSTPROVP,VRPSTPROVAB,VRPSTFRACHT,VRPSTFRACHTAB,VRPSTFRME,VRPSTIMP,VRPSTVERSP,VRPSTVERSAB,VRPDUTY,VRPSTZOLLP,VRPSTZOLLAB,VRPFOB,VRPFRGR,VRPFRGRME,VRPFRGRAB,VRPVERSGR,VRPVERSGRAB,VRPROHWERT,VRPROHWERTAB,VRPCOBORDER,VRPZOLLTNR,VRPURLAND,VRPPRFBEG,VRPPRFSCHL,VRPLGERKLNR,VRPURZEUGKZ,VRPVERZKZ,VRPZOLAGER,VRPEZOLLTNR,VRPZFORMNR,VRPZFORMDAT,VRPAVVME,VRPUEBKZ,VRPZOLLANM,VRPSTATIST,VRPPRURLAND,VRPVGBETRAG,VRPIPFRACHT,VRPIPVERSICH,VRPIPVERPKO,VRPIPZOLL,VRPIPIMP,VRPAELFDNRO,VRPAELFDNRE,VRPAEDATUM,VRPNEMENGE,VRPNEMENGET1,VRPNEMENGET2,VRPNEMENGET3,VRPNEMENGET4,VRPFAKMEKZ,VRPZUABKZ1,VRPZUABKZ2,VRPZUABKZ3,VRPZUABKZ4,VRPZUABKZ5,VRPZUABMG1,VRPZUABMG2,VRPZUABMG3,VRPZUABMG4,VRPZUABMG5,VRPPROGRP,VRPARTGRP,VRPBUSIMODE,VRPINTRA,VRPAPOSTYP,VRPNIXVV,VRPVERSLO,VRPEMPLAND,VRPWOHER1,VRPANTEIL1,VRPWOHER2,VRPANTEIL2,VRPWOHER3,VRPANTEIL3,VRPWOHER4,VRPANTEIL4,VRPANTSUMME,VRPVRFM06,VRPAFOLGE,VRPWEBER,VRPDRVERT,VRPCBOOKNO,VRPCITEMNO,VRPZUSTAND,VRPPACKANZ,VRPBRTGEW,VRPFILLER4,VRPAENZL,VRPAENB,VRPAEND,VRPNEUB,VRPNEUD)"
                    + " VALUES (:VRPMANDANT:,:VRPRENR:,:VRPREPOS:,:VRPFILLER1:,:VRPAUFKRS:,:VRPAUFLFD:,:VRPAUFPOS:,:VRPLIEFSCH:,:VRPWAWERT:,:VRPFRACHT:,:VRPVERSICH:,:VRPVERPKO:,:VRPGESWERT:,:VRPVERSART:,:VRPSPED:,:VRPVG:,:VRPRRENR:,:VRPRREPOS:,:VRPKOLL:,:VRPART:,:VRPFARBE:,:VRPZENSUR:,:VRPPRODST:,:VRPARTST:,:VRPMENGE:,:VRPMENGET1:,:VRPMENGET2:,:VRPMENGET3:,:VRPMENGET4:,:VRPMEEH:,:VRPMEEHGRP:,:VRPMEEHFKT:,:VRPFIXMASS:,:VRPANLBRT:,:VRPANLHOE:,:VRPPREIS:,:VRPPREH:,:VRPPREHGRP:,:VRPPREHFKT:,:VRPKONFEKT:,:VRPZUGET:,:VRPZUGETT1:,:VRPZUGETT2:,:VRPZUGETT3:,:VRPZUGETT4:,:VRPGRUND:,:VRPFSCHL:,:VRPVLIEFNR:,:VRPKSTKRS:,:VRPKST:,:VRPRABART1:,:VRPRABPROZ1:,:VRPRABWERT1:,:VRPRABART2:,:VRPRABPROZ2:,:VRPRABWERT2:,:VRPRABART3:,:VRPRABPROZ3:,:VRPRABWERT3:,:VRPRABART4:,:VRPRABPROZ4:,:VRPRABWERT4:,:VRPRABART5:,:VRPRABPROZ5:,:VRPRABWERT5:,:VRPZUART1:,:VRPZUABPROZ1:,:VRPZUABWERT1:,:VRPZUART2:,:VRPZUABPROZ2:,:VRPZUABWERT2:,:VRPZUART3:,:VRPZUABPROZ3:,:VRPZUABWERT3:,:VRPZUART4:,:VRPZUABPROZ4:,:VRPZUABWERT4:,:VRPZUART5:,:VRPZUABPROZ5:,:VRPZUABWERT5:,:VRPVERTNR1:,:VRPPVBAS1:,:VRPPVVAR1:,:VRPPROVA1:,:VRPPROVP1:,:VRPPROVPFL1:,:VRPVERTNR2:,:VRPPVBAS2:,:VRPPVVAR2:,:VRPPROVA2:,:VRPPROVP2:,:VRPPROVPFL2:,:VRPVERTNR3:,:VRPPVBAS3:,:VRPPVVAR3:,:VRPPROVA3:,:VRPPROVP3:,:VRPPROVPFL3:,:VRPVERTNR4:,:VRPPVBAS4:,:VRPPVVAR4:,:VRPPROVA4:,:VRPPROVP4:,:VRPPROVPFL4:,:VRPKDAUFTNR:,:VRPKDAUFDAT:,:VRPKDKONTR:,:VRPTEILNR:,:VRPAPOS:,:VRPERLKZ:,:VRPFWARTGRA:,:VRPERLKTO:,:VRPRWBRT:,:VRPVERSDAT:,:VRPIBRT:,:VRPPRMENGE:,:VRPBERBASIS:,:VRPSTAFFEL:,:VRPSTAFFME:,:VRPWERT:,:VRPAUFMSL:,:VRPPACKTYP:,:VRPANFART:,:VRPANFPROZ:,:VRPANFWERT:,:VRPMRKMPROZ:,:VRPPOSTYP:,:VRPPOSBEZ:,:VRPGRUPPE:,:VRPDRZUSCHL:,:VRPLFMENGE:,:VRPLFMENGET1:,:VRPLFMENGET2:,:VRPLFMENGET3:,:VRPLFMENGET4:,:VRPZUABWT1:,:VRPZUABMEEH1:,:VRPZUABWT2:,:VRPZUABMEEH2:,:VRPZUABWT3:,:VRPZUABMEEH3:,:VRPZUABWT4:,:VRPZUABMEEH4:,:VRPZUABWT5:,:VRPZUABMEEH5:,:VRPRABEB1:,:VRPRABEB2:,:VRPRABEB3:,:VRPRABEB4:,:VRPRABEB5:,:VRPZUAEB1:,:VRPZUAEB2:,:VRPZUAEB3:,:VRPZUAEB4:,:VRPZUAEB5:,:VRPANZPROD:,:VRPFIXBONP:,:VRPFIXBONA:,:VRPBONAEND:,:VRPBONKZ:,:VRPKSTTKZ:,:VRPURAUFKRS:,:VRPURAUFLFD:,:VRPURAUFPOS:,:VRPCOLORIT:,:VRPDESSIN:,:VRPBESCHICH:,:VRPABPVAR:,:VRPMINGRD:,:VRPANLIEF:,:VRPMEEHFB:,:VRPARTKUNDNR:,:VRPTERMNR:,:VRPWAEHRSL:,:VRPKURS:,:VRPBETRAG:,:VRPGROE:,:VRPNRKR:,:VRPLFDNR:,:VRPDATPRUEF:,:VRPSTORNO:,:VRPHWAEHRSL:,:VRPHEUROKURS:,:VRPHEUROKURSVK:,:VRPFEUROKURS:,:VRPFEUROKURSVK:,:VRPSTASCHL:,:VRPSTPROVP:,:VRPSTPROVAB:,:VRPSTFRACHT:,:VRPSTFRACHTAB:,:VRPSTFRME:,:VRPSTIMP:,:VRPSTVERSP:,:VRPSTVERSAB:,:VRPDUTY:,:VRPSTZOLLP:,:VRPSTZOLLAB:,:VRPFOB:,:VRPFRGR:,:VRPFRGRME:,:VRPFRGRAB:,:VRPVERSGR:,:VRPVERSGRAB:,:VRPROHWERT:,:VRPROHWERTAB:,:VRPCOBORDER:,:VRPZOLLTNR:,:VRPURLAND:,:VRPPRFBEG:,:VRPPRFSCHL:,:VRPLGERKLNR:,:VRPURZEUGKZ:,:VRPVERZKZ:,:VRPZOLAGER:,:VRPEZOLLTNR:,:VRPZFORMNR:,:VRPZFORMDAT:,:VRPAVVME:,:VRPUEBKZ:,:VRPZOLLANM:,:VRPSTATIST:,:VRPPRURLAND:,:VRPVGBETRAG:,:VRPIPFRACHT:,:VRPIPVERSICH:,:VRPIPVERPKO:,:VRPIPZOLL:,:VRPIPIMP:,:VRPAELFDNRO:,:VRPAELFDNRE:,:VRPAEDATUM:,:VRPNEMENGE:,:VRPNEMENGET1:,:VRPNEMENGET2:,:VRPNEMENGET3:,:VRPNEMENGET4:,:VRPFAKMEKZ:,:VRPZUABKZ1:,:VRPZUABKZ2:,:VRPZUABKZ3:,:VRPZUABKZ4:,:VRPZUABKZ5:,:VRPZUABMG1:,:VRPZUABMG2:,:VRPZUABMG3:,:VRPZUABMG4:,:VRPZUABMG5:,:VRPPROGRP:,:VRPARTGRP:,:VRPBUSIMODE:,:VRPINTRA:,:VRPAPOSTYP:,:VRPNIXVV:,:VRPVERSLO:,:VRPEMPLAND:,:VRPWOHER1:,:VRPANTEIL1:,:VRPWOHER2:,:VRPANTEIL2:,:VRPWOHER3:,:VRPANTEIL3:,:VRPWOHER4:,:VRPANTEIL4:,:VRPANTSUMME:,:VRPVRFM06:,:VRPAFOLGE:,:VRPWEBER:,:VRPDRVERT:,:VRPCBOOKNO:,:VRPCITEMNO:,:VRPZUSTAND:,:VRPPACKANZ:,:VRPBRTGEW:,:VRPFILLER4:,:VRPAENZL:,:VRPAENB:,:VRPAEND:,:VRPNEUB:,:VRPNEUD:)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case "JLT":
                    or1.CommandText = "INSERT INTO VRPOS ( VRPMANDANT,VRPRENR,VRPREPOS,VRPFILLER1,VRPAUFKRS,VRPAUFLFD,VRPAUFPOS,VRPLIEFSCH,VRPWAWERT,VRPFRACHT,VRPVERSICH,VRPVERPKO,VRPGESWERT,VRPVERSART,VRPSPED,VRPVG,VRPRRENR,VRPRREPOS,VRPKOLL,VRPART,VRPFARBE,VRPZENSUR,VRPPRODST,VRPARTST,VRPMENGE,VRPMENGET1,VRPMENGET2,VRPMENGET3,VRPMENGET4,VRPMEEH,VRPMEEHGRP,VRPMEEHFKT,VRPFIXMASS,VRPANLBRT,VRPANLHOE,VRPPREIS,VRPPREH,VRPPREHGRP,VRPPREHFKT,VRPKONFEKT,VRPZUGET,VRPZUGETT1,VRPZUGETT2,VRPZUGETT3,VRPZUGETT4,VRPGRUND,VRPFSCHL,VRPVLIEFNR,VRPKSTKRS,VRPKST,VRPRABART1,VRPRABPROZ1,VRPRABWERT1,VRPRABART2,VRPRABPROZ2,VRPRABWERT2,VRPRABART3,VRPRABPROZ3,VRPRABWERT3,VRPRABART4,VRPRABPROZ4,VRPRABWERT4,VRPRABART5,VRPRABPROZ5,VRPRABWERT5,VRPZUART1,VRPZUABPROZ1,VRPZUABWERT1,VRPZUART2,VRPZUABPROZ2,VRPZUABWERT2,VRPZUART3,VRPZUABPROZ3,VRPZUABWERT3,VRPZUART4,VRPZUABPROZ4,VRPZUABWERT4,VRPZUART5,VRPZUABPROZ5,VRPZUABWERT5,VRPVERTNR1,VRPPVBAS1,VRPPVVAR1,VRPPROVA1,VRPPROVP1,VRPPROVPFL1,VRPVERTNR2,VRPPVBAS2,VRPPVVAR2,VRPPROVA2,VRPPROVP2,VRPPROVPFL2,VRPVERTNR3,VRPPVBAS3,VRPPVVAR3,VRPPROVA3,VRPPROVP3,VRPPROVPFL3,VRPVERTNR4,VRPPVBAS4,VRPPVVAR4,VRPPROVA4,VRPPROVP4,VRPPROVPFL4,VRPKDAUFTNR,VRPKDAUFDAT,VRPKDKONTR,VRPTEILNR,VRPAPOS,VRPERLKZ,VRPFWARTGRA,VRPERLKTO,VRPRWBRT,VRPVERSDAT,VRPIBRT,VRPPRMENGE,VRPBERBASIS,VRPSTAFFEL,VRPSTAFFME,VRPWERT,VRPAUFMSL,VRPPACKTYP,VRPANFART,VRPANFPROZ,VRPANFWERT,VRPMRKMPROZ,VRPPOSTYP,VRPPOSBEZ,VRPGRUPPE,VRPDRZUSCHL,VRPLFMENGE,VRPLFMENGET1,VRPLFMENGET2,VRPLFMENGET3,VRPLFMENGET4,VRPZUABWT1,VRPZUABMEEH1,VRPZUABWT2,VRPZUABMEEH2,VRPZUABWT3,VRPZUABMEEH3,VRPZUABWT4,VRPZUABMEEH4,VRPZUABWT5,VRPZUABMEEH5,VRPRABEB1,VRPRABEB2,VRPRABEB3,VRPRABEB4,VRPRABEB5,VRPZUAEB1,VRPZUAEB2,VRPZUAEB3,VRPZUAEB4,VRPZUAEB5,VRPANZPROD,VRPFIXBONP,VRPFIXBONA,VRPBONAEND,VRPBONKZ,VRPKSTTKZ,VRPURAUFKRS,VRPURAUFLFD,VRPURAUFPOS,VRPCOLORIT,VRPDESSIN,VRPBESCHICH,VRPABPVAR,VRPMINGRD,VRPANLIEF,VRPMEEHFB,VRPARTKUNDNR,VRPTERMNR,VRPWAEHRSL,VRPKURS,VRPBETRAG,VRPGROE,VRPNRKR,VRPLFDNR,VRPDATPRUEF,VRPSTORNO,VRPHWAEHRSL,VRPHEUROKURS,VRPHEUROKURSVK,VRPFEUROKURS,VRPFEUROKURSVK,VRPSTASCHL,VRPSTPROVP,VRPSTPROVAB,VRPSTFRACHT,VRPSTFRACHTAB,VRPSTFRME,VRPSTIMP,VRPSTVERSP,VRPSTVERSAB,VRPDUTY,VRPSTZOLLP,VRPSTZOLLAB,VRPFOB,VRPFRGR,VRPFRGRME,VRPFRGRAB,VRPVERSGR,VRPVERSGRAB,VRPROHWERT,VRPROHWERTAB,VRPCOBORDER,VRPZOLLTNR,VRPURLAND,VRPPRFBEG,VRPPRFSCHL,VRPLGERKLNR,VRPURZEUGKZ,VRPVERZKZ,VRPZOLAGER,VRPEZOLLTNR,VRPZFORMNR,VRPZFORMDAT,VRPAVVME,VRPUEBKZ,VRPZOLLANM,VRPSTATIST,VRPPRURLAND,VRPVGBETRAG,VRPIPFRACHT,VRPIPVERSICH,VRPIPVERPKO,VRPIPZOLL,VRPIPIMP,VRPAELFDNRO,VRPAELFDNRE,VRPAEDATUM,VRPNEMENGE,VRPNEMENGET1,VRPNEMENGET2,VRPNEMENGET3,VRPNEMENGET4,VRPFAKMEKZ,VRPZUABKZ1,VRPZUABKZ2,VRPZUABKZ3,VRPZUABKZ4,VRPZUABKZ5,VRPZUABMG1,VRPZUABMG2,VRPZUABMG3,VRPZUABMG4,VRPZUABMG5,VRPPROGRP,VRPARTGRP,VRPBUSIMODE,VRPINTRA,VRPAPOSTYP,VRPNIXVV,VRPVERSLO,VRPEMPLAND,VRPWOHER1,VRPANTEIL1,VRPWOHER2,VRPANTEIL2,VRPWOHER3,VRPANTEIL3,VRPWOHER4,VRPANTEIL4,VRPANTSUMME,VRPVRFM06,VRPAFOLGE,VRPWEBER,VRPDRVERT,VRPCBOOKNO,VRPCITEMNO,VRPZUSTAND,VRPPACKANZ,VRPBRTGEW,VRPFILLER4,VRPAENZL,VRPAENB,VRPAEND,VRPNEUB,VRPNEUD)"
                    + " VALUES (:VRPMANDANT:,:VRPRENR:,:VRPREPOS:,:VRPFILLER1:,:VRPAUFKRS:,:VRPAUFLFD:,:VRPAUFPOS:,:VRPLIEFSCH:,:VRPWAWERT:,:VRPFRACHT:,:VRPVERSICH:,:VRPVERPKO:,:VRPGESWERT:,:VRPVERSART:,:VRPSPED:,:VRPVG:,:VRPRRENR:,:VRPRREPOS:,:VRPKOLL:,:VRPART:,:VRPFARBE:,:VRPZENSUR:,:VRPPRODST:,:VRPARTST:,:VRPMENGE:,:VRPMENGET1:,:VRPMENGET2:,:VRPMENGET3:,:VRPMENGET4:,:VRPMEEH:,:VRPMEEHGRP:,:VRPMEEHFKT:,:VRPFIXMASS:,:VRPANLBRT:,:VRPANLHOE:,:VRPPREIS:,:VRPPREH:,:VRPPREHGRP:,:VRPPREHFKT:,:VRPKONFEKT:,:VRPZUGET:,:VRPZUGETT1:,:VRPZUGETT2:,:VRPZUGETT3:,:VRPZUGETT4:,:VRPGRUND:,:VRPFSCHL:,:VRPVLIEFNR:,:VRPKSTKRS:,:VRPKST:,:VRPRABART1:,:VRPRABPROZ1:,:VRPRABWERT1:,:VRPRABART2:,:VRPRABPROZ2:,:VRPRABWERT2:,:VRPRABART3:,:VRPRABPROZ3:,:VRPRABWERT3:,:VRPRABART4:,:VRPRABPROZ4:,:VRPRABWERT4:,:VRPRABART5:,:VRPRABPROZ5:,:VRPRABWERT5:,:VRPZUART1:,:VRPZUABPROZ1:,:VRPZUABWERT1:,:VRPZUART2:,:VRPZUABPROZ2:,:VRPZUABWERT2:,:VRPZUART3:,:VRPZUABPROZ3:,:VRPZUABWERT3:,:VRPZUART4:,:VRPZUABPROZ4:,:VRPZUABWERT4:,:VRPZUART5:,:VRPZUABPROZ5:,:VRPZUABWERT5:,:VRPVERTNR1:,:VRPPVBAS1:,:VRPPVVAR1:,:VRPPROVA1:,:VRPPROVP1:,:VRPPROVPFL1:,:VRPVERTNR2:,:VRPPVBAS2:,:VRPPVVAR2:,:VRPPROVA2:,:VRPPROVP2:,:VRPPROVPFL2:,:VRPVERTNR3:,:VRPPVBAS3:,:VRPPVVAR3:,:VRPPROVA3:,:VRPPROVP3:,:VRPPROVPFL3:,:VRPVERTNR4:,:VRPPVBAS4:,:VRPPVVAR4:,:VRPPROVA4:,:VRPPROVP4:,:VRPPROVPFL4:,:VRPKDAUFTNR:,:VRPKDAUFDAT:,:VRPKDKONTR:,:VRPTEILNR:,:VRPAPOS:,:VRPERLKZ:,:VRPFWARTGRA:,:VRPERLKTO:,:VRPRWBRT:,:VRPVERSDAT:,:VRPIBRT:,:VRPPRMENGE:,:VRPBERBASIS:,:VRPSTAFFEL:,:VRPSTAFFME:,:VRPWERT:,:VRPAUFMSL:,:VRPPACKTYP:,:VRPANFART:,:VRPANFPROZ:,:VRPANFWERT:,:VRPMRKMPROZ:,:VRPPOSTYP:,:VRPPOSBEZ:,:VRPGRUPPE:,:VRPDRZUSCHL:,:VRPLFMENGE:,:VRPLFMENGET1:,:VRPLFMENGET2:,:VRPLFMENGET3:,:VRPLFMENGET4:,:VRPZUABWT1:,:VRPZUABMEEH1:,:VRPZUABWT2:,:VRPZUABMEEH2:,:VRPZUABWT3:,:VRPZUABMEEH3:,:VRPZUABWT4:,:VRPZUABMEEH4:,:VRPZUABWT5:,:VRPZUABMEEH5:,:VRPRABEB1:,:VRPRABEB2:,:VRPRABEB3:,:VRPRABEB4:,:VRPRABEB5:,:VRPZUAEB1:,:VRPZUAEB2:,:VRPZUAEB3:,:VRPZUAEB4:,:VRPZUAEB5:,:VRPANZPROD:,:VRPFIXBONP:,:VRPFIXBONA:,:VRPBONAEND:,:VRPBONKZ:,:VRPKSTTKZ:,:VRPURAUFKRS:,:VRPURAUFLFD:,:VRPURAUFPOS:,:VRPCOLORIT:,:VRPDESSIN:,:VRPBESCHICH:,:VRPABPVAR:,:VRPMINGRD:,:VRPANLIEF:,:VRPMEEHFB:,:VRPARTKUNDNR:,:VRPTERMNR:,:VRPWAEHRSL:,:VRPKURS:,:VRPBETRAG:,:VRPGROE:,:VRPNRKR:,:VRPLFDNR:,:VRPDATPRUEF:,:VRPSTORNO:,:VRPHWAEHRSL:,:VRPHEUROKURS:,:VRPHEUROKURSVK:,:VRPFEUROKURS:,:VRPFEUROKURSVK:,:VRPSTASCHL:,:VRPSTPROVP:,:VRPSTPROVAB:,:VRPSTFRACHT:,:VRPSTFRACHTAB:,:VRPSTFRME:,:VRPSTIMP:,:VRPSTVERSP:,:VRPSTVERSAB:,:VRPDUTY:,:VRPSTZOLLP:,:VRPSTZOLLAB:,:VRPFOB:,:VRPFRGR:,:VRPFRGRME:,:VRPFRGRAB:,:VRPVERSGR:,:VRPVERSGRAB:,:VRPROHWERT:,:VRPROHWERTAB:,:VRPCOBORDER:,:VRPZOLLTNR:,:VRPURLAND:,:VRPPRFBEG:,:VRPPRFSCHL:,:VRPLGERKLNR:,:VRPURZEUGKZ:,:VRPVERZKZ:,:VRPZOLAGER:,:VRPEZOLLTNR:,:VRPZFORMNR:,:VRPZFORMDAT:,:VRPAVVME:,:VRPUEBKZ:,:VRPZOLLANM:,:VRPSTATIST:,:VRPPRURLAND:,:VRPVGBETRAG:,:VRPIPFRACHT:,:VRPIPVERSICH:,:VRPIPVERPKO:,:VRPIPZOLL:,:VRPIPIMP:,:VRPAELFDNRO:,:VRPAELFDNRE:,:VRPAEDATUM:,:VRPNEMENGE:,:VRPNEMENGET1:,:VRPNEMENGET2:,:VRPNEMENGET3:,:VRPNEMENGET4:,:VRPFAKMEKZ:,:VRPZUABKZ1:,:VRPZUABKZ2:,:VRPZUABKZ3:,:VRPZUABKZ4:,:VRPZUABKZ5:,:VRPZUABMG1:,:VRPZUABMG2:,:VRPZUABMG3:,:VRPZUABMG4:,:VRPZUABMG5:,:VRPPROGRP:,:VRPARTGRP:,:VRPBUSIMODE:,:VRPINTRA:,:VRPAPOSTYP:,:VRPNIXVV:,:VRPVERSLO:,:VRPEMPLAND:,:VRPWOHER1:,:VRPANTEIL1:,:VRPWOHER2:,:VRPANTEIL2:,:VRPWOHER3:,:VRPANTEIL3:,:VRPWOHER4:,:VRPANTEIL4:,:VRPANTSUMME:,:VRPVRFM06:,:VRPAFOLGE:,:VRPWEBER:,:VRPDRVERT:,:VRPCBOOKNO:,:VRPCITEMNO:,:VRPZUSTAND:,:VRPPACKANZ:,:VRPBRTGEW:,:VRPFILLER4:,:VRPAENZL:,:VRPAENB:,:VRPAEND:,:VRPNEUB:,:VRPNEUD:)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
            }
            Connect2Proxy(or1);
        }

        public DataSet QueryVRPOS(DataRow dwData, int option = 1)
        {
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM VRPOS WHERE  ROWNUM<2 ";
                    SResult = Connect2Proxy(or1);
                    break;
                case 1:
                    or1.CommandText = "SELECT * FROM VRPOS WHERE  "
                      + "  VRPMANDANT=:VRPMANDANT:  AND VRPRENR=:VRPRENR: AND VRPREPOS=:VRPREPOS:"
                         + " ORDER BY VRPZOLLTNR,VRPRENR,VRPREPOS";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1);
                    break;
                case 2:
                    or1.CommandText = "SELECT M.* FROM VRPOS M WHERE  "
                        + "  VRPMANDANT=:VRPMANDANT:  AND VRPRENR=:VRPRENR:"
                           + " ORDER BY VRPZOLLTNR,VRPRENR,VRPREPOS";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1);
                    break;
                case 3:
                    or1.CommandText = "SELECT  VRPRENR||VRPREPOS AS KEY,P.* FROM VRPOS P WHERE  "
                        + "  VRPMANDANT=:VRPMANDANT:  AND VRPLIEFSCH=:VRPLIEFSCH:"
                         + " ORDER BY VRPZOLLTNR,VRPRENR,VRPREPOS";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1);
                    break;
                case 4: SResult = QVRP04(dwData); break;
                case 5: SResult = QVRP05(dwData); break;
                case 6: SResult = QVRP06(dwData); break;
                case 7:
                    or1.CommandText = "SELECT  VRPRENR||VRPREPOS AS KEY,P.* FROM VRPOS P JOIN VRKOPF ON WHERE VRKMANDANT=VRPMANDANT AND VRKRENR=VRPRENR  "
                        + "  VRPMANDANT=:VRPMANDANT:  AND VRPAUFKRS LIKE '%" + dwData["VRPAUFKRS"].ToString() + "%' AND VRPAUFLFD LIKE '%" + dwData["VRPAUFLFD"].ToString() + "%' "
                        + dwData["VRPBONKZ"].ToString()
                        + " AND VRKKUNDNRVK LIKE '" + dwData["VRPARTKUNDNR"].ToString() + "%'"
                         + " ORDER BY VRPZOLLTNR,VRPRENR,VRPREPOS";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1);
                    break;
                case 8: SResult = QVRP08(dwData); break;
                case 9: SResult = QVRP09(dwData); break;
                case 10: SResult = QVRP10(dwData); break;
                default: break;
            }

            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVRP04(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT VRPRENR||VRPREPOS AS KEY,P.* FROM VRPOS P WHERE  "
                         + "  VRPMANDANT=:VRPMANDANT: AND VRPSTATIST=:VRPSTATIST: AND VRPAUFKRS=:VRPAUFKRS: AND VRPAUFLFD=:VRPAUFLFD:  AND VRPAUFPOS=:VRPAUFPOS:"
                         + dwData["VRPZOLLTNR"].ToString()
                         + " ORDER BY VRPZOLLTNR,VRPRENR,VRPREPOS";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVRP05(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT  VRPRENR||VRPREPOS AS KEY,P.* FROM VRPOS P WHERE  "
                + "  VRPMANDANT=:VRPMANDANT:  AND VRPRENR=:VRPRENR: AND VRPREPOS=:VRPREPOS:"
                 + " ORDER BY VRPZOLLTNR,VRPRENR,VRPREPOS";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);

            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVRP06(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT  VRPRENR||VRPREPOS AS KEY,P.* FROM VRPOS P "
                    + " WHERE VRPSTATIST=:VRPSTATIST: AND VRPMANDANT=:VRPMANDANT:  AND VRPAUFKRS=:VRPAUFKRS: AND VRPAUFLFD=:VRPAUFLFD:"
                    + dwData["VRPRENR"].ToString()
                     + " ORDER BY VRPZOLLTNR,VRPRENR,VRPREPOS";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVRP08(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT MAX(VRPREPOS) AS VRPREPOS  FROM VRPOS WHERE  "
                         + "  VRPMANDANT=:VRPMANDANT:  AND VRPAUFKRS=:VRPAUFKRS: AND VRPAUFLFD=:VRPAUFLFD: AND VRPAUFPOS=:VRPAUFPOS:";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVRP09(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT MAX(VRPREPOS) AS VRPREPOS  FROM VRPOS WHERE  "
                        + "  VRPMANDANT=:VRPMANDANT:  AND VRPAUFLFD=:VRPAUFLFD: ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QVRP10(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT  VRPRENR||VRPREPOS AS KEY,P.* FROM VRPOS P "
            + " WHERE VRPSTATIST=:VRPSTATIST: AND VRPMANDANT=:VRPMANDANT: "
            + dwData["VRPVLIEFNR"].ToString()
             + dwData["VRPAUFKRS"].ToString()
              + dwData["VRPAUFLFD"].ToString()
            + dwData["VRPRENR"].ToString()
            + dwData["VRPFILLER4"].ToString()

             + " ORDER BY VRPZOLLTNR,VRPRENR,VRPREPOS";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public void DeleteVRPOS(DataRow dwData, int option = 1)
        {
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "DELETE  FROM VRPOS WHERE  "
                        + "  VRPMANDANT=:VRPMANDANT:  AND VRPAUFKRS=:VRPAUFKRS: AND VRPSTATIST=:VRPSTATIST:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 1:
                    or1.CommandText = "DELETE  FROM VRPOS WHERE  "
                        + "  VRPMANDANT=:VRPMANDANT:  AND VRPRENR=:VRPRENR: AND VRPREPOS=:VRPREPOS:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 2:
                    or1.CommandText = "DELETE  FROM VRPOS WHERE  "
                        + "  VRPMANDANT=:VRPMANDANT: AND VRPRENR=:VRPRENR: AND VRPSTATIST=:VRPSTATIST: AND VRPAUFKRS=:VRPAUFKRS: AND VRPAUFLFD=:VRPAUFLFD: ";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 3:
                    or1.CommandText = "DELETE  FROM VRPOS WHERE VRPMANDANT=:VRPMANDANT:  ";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        }

        public void UpdateVRPOS(DataRow dwData, int option = 1)
        {
            if (dwData != null)
            {
                dwData["VRPAENB"] = app.User;
                dwData["VRPAEND"] = date;
            }
            if (option == 0)
            {
                switch (app.company)
                {
                    default:
                    case "YGR":
                    case "TST":
                        option = 1;
                        break;
                    case "JLT":
                        option = 2;
                        break;
                }
            }
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "UPDATE VRPOS SET VRPMANDANT=:VRPMANDANT:,VRPRENR=:VRPRENR:,VRPREPOS=:VRPREPOS:,VRPFILLER1=:VRPFILLER1:,VRPAUFKRS=:VRPAUFKRS:,VRPAUFLFD=:VRPAUFLFD:,VRPAUFPOS=:VRPAUFPOS:,VRPLIEFSCH=:VRPLIEFSCH:,VRPWAWERT=:VRPWAWERT:,VRPFRACHT=:VRPFRACHT:,VRPVERSICH=:VRPVERSICH:,VRPVERPKO=:VRPVERPKO:,VRPGESWERT=:VRPGESWERT:,VRPVERSART=:VRPVERSART:,VRPSPED=:VRPSPED:,VRPVG=:VRPVG:,VRPRRENR=:VRPRRENR:,VRPRREPOS=:VRPRREPOS:,VRPKOLL=:VRPKOLL:,VRPART=:VRPART:,VRPFARBE=:VRPFARBE:,VRPZENSUR=:VRPZENSUR:,VRPPRODST=:VRPPRODST:,VRPARTST=:VRPARTST:,VRPMENGE=:VRPMENGE:,VRPMENGET1=:VRPMENGET1:,VRPMENGET2=:VRPMENGET2:,VRPMENGET3=:VRPMENGET3:,VRPMENGET4=:VRPMENGET4:,VRPMEEH=:VRPMEEH:,VRPMEEHGRP=:VRPMEEHGRP:,VRPMEEHFKT=:VRPMEEHFKT:,VRPFIXMASS=:VRPFIXMASS:,VRPANLBRT=:VRPANLBRT:,VRPANLHOE=:VRPANLHOE:,VRPPREIS=:VRPPREIS:,VRPPREH=:VRPPREH:,VRPPREHGRP=:VRPPREHGRP:,VRPPREHFKT=:VRPPREHFKT:,VRPKONFEKT=:VRPKONFEKT:,VRPZUGET=:VRPZUGET:,VRPZUGETT1=:VRPZUGETT1:,VRPZUGETT2=:VRPZUGETT2:,VRPZUGETT3=:VRPZUGETT3:,VRPZUGETT4=:VRPZUGETT4:,VRPGRUND=:VRPGRUND:,VRPFSCHL=:VRPFSCHL:,VRPVLIEFNR=:VRPVLIEFNR:,VRPKSTKRS=:VRPKSTKRS:,VRPKST=:VRPKST:,VRPRABART1=:VRPRABART1:,VRPRABPROZ1=:VRPRABPROZ1:,VRPRABWERT1=:VRPRABWERT1:,VRPRABART2=:VRPRABART2:,VRPRABPROZ2=:VRPRABPROZ2:,VRPRABWERT2=:VRPRABWERT2:,VRPRABART3=:VRPRABART3:,VRPRABPROZ3=:VRPRABPROZ3:,VRPRABWERT3=:VRPRABWERT3:,VRPRABART4=:VRPRABART4:,VRPRABPROZ4=:VRPRABPROZ4:,VRPRABWERT4=:VRPRABWERT4:,VRPRABART5=:VRPRABART5:,VRPRABPROZ5=:VRPRABPROZ5:,VRPRABWERT5=:VRPRABWERT5:,VRPZUART1=:VRPZUART1:,VRPZUABPROZ1=:VRPZUABPROZ1:,VRPZUABWERT1=:VRPZUABWERT1:,VRPZUART2=:VRPZUART2:,VRPZUABPROZ2=:VRPZUABPROZ2:,VRPZUABWERT2=:VRPZUABWERT2:,VRPZUART3=:VRPZUART3:,VRPZUABPROZ3=:VRPZUABPROZ3:,VRPZUABWERT3=:VRPZUABWERT3:,VRPZUART4=:VRPZUART4:,VRPZUABPROZ4=:VRPZUABPROZ4:,VRPZUABWERT4=:VRPZUABWERT4:,VRPZUART5=:VRPZUART5:,VRPZUABPROZ5=:VRPZUABPROZ5:,VRPZUABWERT5=:VRPZUABWERT5:,VRPVERTNR1=:VRPVERTNR1:,VRPPVBAS1=:VRPPVBAS1:,VRPPVVAR1=:VRPPVVAR1:,VRPPROVA1=:VRPPROVA1:,VRPPROVP1=:VRPPROVP1:,VRPPROVPFL1=:VRPPROVPFL1:,VRPVERTNR2=:VRPVERTNR2:,VRPPVBAS2=:VRPPVBAS2:,VRPPVVAR2=:VRPPVVAR2:,VRPPROVA2=:VRPPROVA2:,VRPPROVP2=:VRPPROVP2:,VRPPROVPFL2=:VRPPROVPFL2:,VRPVERTNR3=:VRPVERTNR3:,VRPPVBAS3=:VRPPVBAS3:,VRPPVVAR3=:VRPPVVAR3:,VRPPROVA3=:VRPPROVA3:,VRPPROVP3=:VRPPROVP3:,VRPPROVPFL3=:VRPPROVPFL3:,VRPVERTNR4=:VRPVERTNR4:,VRPPVBAS4=:VRPPVBAS4:,VRPPVVAR4=:VRPPVVAR4:,VRPPROVA4=:VRPPROVA4:,VRPPROVP4=:VRPPROVP4:,VRPPROVPFL4=:VRPPROVPFL4:,VRPKDAUFTNR=:VRPKDAUFTNR:,VRPKDAUFDAT=:VRPKDAUFDAT:,VRPKDKONTR=:VRPKDKONTR:,VRPTEILNR=:VRPTEILNR:,VRPAPOS=:VRPAPOS:,VRPERLKZ=:VRPERLKZ:,VRPFWARTGRA=:VRPFWARTGRA:,VRPERLKTO=:VRPERLKTO:,VRPRWBRT=:VRPRWBRT:,VRPVERSDAT=:VRPVERSDAT:,VRPIBRT=:VRPIBRT:,VRPPRMENGE=:VRPPRMENGE:,VRPBERBASIS=:VRPBERBASIS:,VRPSTAFFEL=:VRPSTAFFEL:,VRPSTAFFME=:VRPSTAFFME:,VRPWERT=:VRPWERT:,VRPAUFMSL=:VRPAUFMSL:,VRPPACKTYP=:VRPPACKTYP:,VRPANFART=:VRPANFART:,VRPANFPROZ=:VRPANFPROZ:,VRPANFWERT=:VRPANFWERT:,VRPMRKMPROZ=:VRPMRKMPROZ:,VRPPOSTYP=:VRPPOSTYP:,VRPPOSBEZ=:VRPPOSBEZ:,VRPGRUPPE=:VRPGRUPPE:,VRPDRZUSCHL=:VRPDRZUSCHL:,VRPLFMENGE=:VRPLFMENGE:,VRPLFMENGET1=:VRPLFMENGET1:,VRPLFMENGET2=:VRPLFMENGET2:,VRPLFMENGET3=:VRPLFMENGET3:,VRPLFMENGET4=:VRPLFMENGET4:,VRPZUABWT1=:VRPZUABWT1:,VRPZUABMEEH1=:VRPZUABMEEH1:,VRPZUABWT2=:VRPZUABWT2:,VRPZUABMEEH2=:VRPZUABMEEH2:,VRPZUABWT3=:VRPZUABWT3:,VRPZUABMEEH3=:VRPZUABMEEH3:,VRPZUABWT4=:VRPZUABWT4:,VRPZUABMEEH4=:VRPZUABMEEH4:,VRPZUABWT5=:VRPZUABWT5:,VRPZUABMEEH5=:VRPZUABMEEH5:,VRPRABEB1=:VRPRABEB1:,VRPRABEB2=:VRPRABEB2:,VRPRABEB3=:VRPRABEB3:,VRPRABEB4=:VRPRABEB4:,VRPRABEB5=:VRPRABEB5:,VRPZUAEB1=:VRPZUAEB1:,VRPZUAEB2=:VRPZUAEB2:,VRPZUAEB3=:VRPZUAEB3:,VRPZUAEB4=:VRPZUAEB4:,VRPZUAEB5=:VRPZUAEB5:,VRPANZPROD=:VRPANZPROD:,VRPFIXBONP=:VRPFIXBONP:,VRPFIXBONA=:VRPFIXBONA:,VRPBONAEND=:VRPBONAEND:,VRPBONKZ=:VRPBONKZ:,VRPKSTTKZ=:VRPKSTTKZ:,VRPURAUFKRS=:VRPURAUFKRS:,VRPURAUFLFD=:VRPURAUFLFD:,VRPURAUFPOS=:VRPURAUFPOS:,VRPCOLORIT=:VRPCOLORIT:,VRPDESSIN=:VRPDESSIN:,VRPBESCHICH=:VRPBESCHICH:,VRPABPVAR=:VRPABPVAR:,VRPMINGRD=:VRPMINGRD:,VRPANLIEF=:VRPANLIEF:,VRPMEEHFB=:VRPMEEHFB:,VRPARTKUNDNR=:VRPARTKUNDNR:,VRPTERMNR=:VRPTERMNR:,VRPWAEHRSL=:VRPWAEHRSL:,VRPKURS=:VRPKURS:,VRPBETRAG=:VRPBETRAG:,VRPGROE=:VRPGROE:,VRPNRKR=:VRPNRKR:,VRPLFDNR=:VRPLFDNR:,VRPDATPRUEF=:VRPDATPRUEF:,VRPSTORNO=:VRPSTORNO:,VRPHWAEHRSL=:VRPHWAEHRSL:,VRPHEUROKURS=:VRPHEUROKURS:,VRPHEUROKURSVK=:VRPHEUROKURSVK:,VRPFEUROKURS=:VRPFEUROKURS:,VRPFEUROKURSVK=:VRPFEUROKURSVK:,VRPSTASCHL=:VRPSTASCHL:,VRPSTPROVP=:VRPSTPROVP:,VRPSTPROVAB=:VRPSTPROVAB:,VRPSTFRACHT=:VRPSTFRACHT:,VRPSTFRACHTAB=:VRPSTFRACHTAB:,VRPSTFRME=:VRPSTFRME:,VRPSTIMP=:VRPSTIMP:,VRPSTVERSP=:VRPSTVERSP:,VRPSTVERSAB=:VRPSTVERSAB:,VRPDUTY=:VRPDUTY:,VRPSTZOLLP=:VRPSTZOLLP:,VRPSTZOLLAB=:VRPSTZOLLAB:,VRPFOB=:VRPFOB:,VRPFRGR=:VRPFRGR:,VRPFRGRME=:VRPFRGRME:,VRPFRGRAB=:VRPFRGRAB:,VRPVERSGR=:VRPVERSGR:,VRPVERSGRAB=:VRPVERSGRAB:,VRPROHWERT=:VRPROHWERT:,VRPROHWERTAB=:VRPROHWERTAB:,VRPCOBORDER=:VRPCOBORDER:,VRPZOLLTNR=:VRPZOLLTNR:,VRPURLAND=:VRPURLAND:,VRPPRFBEG=:VRPPRFBEG:,VRPPRFSCHL=:VRPPRFSCHL:,VRPLGERKLNR=:VRPLGERKLNR:,VRPURZEUGKZ=:VRPURZEUGKZ:,VRPVERZKZ=:VRPVERZKZ:,VRPZOLAGER=:VRPZOLAGER:,VRPEZOLLTNR=:VRPEZOLLTNR:,VRPZFORMNR=:VRPZFORMNR:,VRPZFORMDAT=:VRPZFORMDAT:,VRPAVVME=:VRPAVVME:,VRPUEBKZ=:VRPUEBKZ:,VRPZOLLANM=:VRPZOLLANM:,VRPSTATIST=:VRPSTATIST:,VRPPRURLAND=:VRPPRURLAND:,VRPVGBETRAG=:VRPVGBETRAG:,VRPIPFRACHT=:VRPIPFRACHT:,VRPIPVERSICH=:VRPIPVERSICH:,VRPIPVERPKO=:VRPIPVERPKO:,VRPIPZOLL=:VRPIPZOLL:,VRPIPIMP=:VRPIPIMP:,VRPAELFDNRO=:VRPAELFDNRO:,VRPAELFDNRE=:VRPAELFDNRE:,VRPAEDATUM=:VRPAEDATUM:,VRPNEMENGE=:VRPNEMENGE:,VRPNEMENGET1=:VRPNEMENGET1:,VRPNEMENGET2=:VRPNEMENGET2:,VRPNEMENGET3=:VRPNEMENGET3:,VRPNEMENGET4=:VRPNEMENGET4:,VRPFAKMEKZ=:VRPFAKMEKZ:,VRPZUABKZ1=:VRPZUABKZ1:,VRPZUABKZ2=:VRPZUABKZ2:,VRPZUABKZ3=:VRPZUABKZ3:,VRPZUABKZ4=:VRPZUABKZ4:,VRPZUABKZ5=:VRPZUABKZ5:,VRPZUABMG1=:VRPZUABMG1:,VRPZUABMG2=:VRPZUABMG2:,VRPZUABMG3=:VRPZUABMG3:,VRPZUABMG4=:VRPZUABMG4:,VRPZUABMG5=:VRPZUABMG5:,VRPPROGRP=:VRPPROGRP:,VRPARTGRP=:VRPARTGRP:,VRPBUSIMODE=:VRPBUSIMODE:,VRPINTRA=:VRPINTRA:,VRPAPOSTYP=:VRPAPOSTYP:,VRPNIXVV=:VRPNIXVV:,VRPVERSLO=:VRPVERSLO:,VRPEMPLAND=:VRPEMPLAND:,VRPWOHER1=:VRPWOHER1:,VRPANTEIL1=:VRPANTEIL1:,VRPWOHER2=:VRPWOHER2:,VRPANTEIL2=:VRPANTEIL2:,VRPWOHER3=:VRPWOHER3:,VRPANTEIL3=:VRPANTEIL3:,VRPWOHER4=:VRPWOHER4:,VRPANTEIL4=:VRPANTEIL4:,VRPANTSUMME=:VRPANTSUMME:,VRPVRFM06=:VRPVRFM06:,VRPAFOLGE=:VRPAFOLGE:,VRPWEBER=:VRPWEBER:,VRPDRVERT=:VRPDRVERT:,VRPCBOOKNO=:VRPCBOOKNO:,VRPCITEMNO=:VRPCITEMNO:,VRPZUSTAND=:VRPZUSTAND:,VRPPACKANZ=:VRPPACKANZ:,VRPBRTGEW=:VRPBRTGEW:,VRPFILLER4=:VRPFILLER4:,VRPAENZL=:VRPAENZL:,VRPAENB=:VRPAENB:,VRPAEND=:VRPAEND:,VRPNEUB=:VRPNEUB:,VRPNEUD=:VRPNEUD:"
                        + " WHERE  VRPMANDANT=:VRPMANDANT: AND VRPRENR=:VRPRENR: AND VRPREPOS =:VRPREPOS: ";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 2:
                    or1.CommandText = "UPDATE VRPOS SET VRPMANDANT=:VRPMANDANT:,VRPRENR=:VRPRENR:,VRPREPOS=:VRPREPOS:,VRPFILLER1=:VRPFILLER1:,VRPAUFKRS=:VRPAUFKRS:,VRPAUFLFD=:VRPAUFLFD:,VRPAUFPOS=:VRPAUFPOS:,VRPLIEFSCH=:VRPLIEFSCH:,VRPWAWERT=:VRPWAWERT:,VRPFRACHT=:VRPFRACHT:,VRPVERSICH=:VRPVERSICH:,VRPVERPKO=:VRPVERPKO:,VRPGESWERT=:VRPGESWERT:,VRPVERSART=:VRPVERSART:,VRPSPED=:VRPSPED:,VRPVG=:VRPVG:,VRPRRENR=:VRPRRENR:,VRPRREPOS=:VRPRREPOS:,VRPKOLL=:VRPKOLL:,VRPART=:VRPART:,VRPFARBE=:VRPFARBE:,VRPZENSUR=:VRPZENSUR:,VRPPRODST=:VRPPRODST:,VRPARTST=:VRPARTST:,VRPMENGE=:VRPMENGE:,VRPMENGET1=:VRPMENGET1:,VRPMENGET2=:VRPMENGET2:,VRPMENGET3=:VRPMENGET3:,VRPMENGET4=:VRPMENGET4:,VRPMEEH=:VRPMEEH:,VRPMEEHGRP=:VRPMEEHGRP:,VRPMEEHFKT=:VRPMEEHFKT:,VRPFIXMASS=:VRPFIXMASS:,VRPANLBRT=:VRPANLBRT:,VRPANLHOE=:VRPANLHOE:,VRPPREIS=:VRPPREIS:,VRPPREH=:VRPPREH:,VRPPREHGRP=:VRPPREHGRP:,VRPPREHFKT=:VRPPREHFKT:,VRPKONFEKT=:VRPKONFEKT:,VRPZUGET=:VRPZUGET:,VRPZUGETT1=:VRPZUGETT1:,VRPZUGETT2=:VRPZUGETT2:,VRPZUGETT3=:VRPZUGETT3:,VRPZUGETT4=:VRPZUGETT4:,VRPGRUND=:VRPGRUND:,VRPFSCHL=:VRPFSCHL:,VRPVLIEFNR=:VRPVLIEFNR:,VRPKSTKRS=:VRPKSTKRS:,VRPKST=:VRPKST:,VRPRABART1=:VRPRABART1:,VRPRABPROZ1=:VRPRABPROZ1:,VRPRABWERT1=:VRPRABWERT1:,VRPRABART2=:VRPRABART2:,VRPRABPROZ2=:VRPRABPROZ2:,VRPRABWERT2=:VRPRABWERT2:,VRPRABART3=:VRPRABART3:,VRPRABPROZ3=:VRPRABPROZ3:,VRPRABWERT3=:VRPRABWERT3:,VRPRABART4=:VRPRABART4:,VRPRABPROZ4=:VRPRABPROZ4:,VRPRABWERT4=:VRPRABWERT4:,VRPRABART5=:VRPRABART5:,VRPRABPROZ5=:VRPRABPROZ5:,VRPRABWERT5=:VRPRABWERT5:,VRPZUART1=:VRPZUART1:,VRPZUABPROZ1=:VRPZUABPROZ1:,VRPZUABWERT1=:VRPZUABWERT1:,VRPZUART2=:VRPZUART2:,VRPZUABPROZ2=:VRPZUABPROZ2:,VRPZUABWERT2=:VRPZUABWERT2:,VRPZUART3=:VRPZUART3:,VRPZUABPROZ3=:VRPZUABPROZ3:,VRPZUABWERT3=:VRPZUABWERT3:,VRPZUART4=:VRPZUART4:,VRPZUABPROZ4=:VRPZUABPROZ4:,VRPZUABWERT4=:VRPZUABWERT4:,VRPZUART5=:VRPZUART5:,VRPZUABPROZ5=:VRPZUABPROZ5:,VRPZUABWERT5=:VRPZUABWERT5:,VRPVERTNR1=:VRPVERTNR1:,VRPPVBAS1=:VRPPVBAS1:,VRPPVVAR1=:VRPPVVAR1:,VRPPROVA1=:VRPPROVA1:,VRPPROVP1=:VRPPROVP1:,VRPPROVPFL1=:VRPPROVPFL1:,VRPVERTNR2=:VRPVERTNR2:,VRPPVBAS2=:VRPPVBAS2:,VRPPVVAR2=:VRPPVVAR2:,VRPPROVA2=:VRPPROVA2:,VRPPROVP2=:VRPPROVP2:,VRPPROVPFL2=:VRPPROVPFL2:,VRPVERTNR3=:VRPVERTNR3:,VRPPVBAS3=:VRPPVBAS3:,VRPPVVAR3=:VRPPVVAR3:,VRPPROVA3=:VRPPROVA3:,VRPPROVP3=:VRPPROVP3:,VRPPROVPFL3=:VRPPROVPFL3:,VRPVERTNR4=:VRPVERTNR4:,VRPPVBAS4=:VRPPVBAS4:,VRPPVVAR4=:VRPPVVAR4:,VRPPROVA4=:VRPPROVA4:,VRPPROVP4=:VRPPROVP4:,VRPPROVPFL4=:VRPPROVPFL4:,VRPKDAUFTNR=:VRPKDAUFTNR:,VRPKDAUFDAT=:VRPKDAUFDAT:,VRPKDKONTR=:VRPKDKONTR:,VRPTEILNR=:VRPTEILNR:,VRPAPOS=:VRPAPOS:,VRPERLKZ=:VRPERLKZ:,VRPFWARTGRA=:VRPFWARTGRA:,VRPERLKTO=:VRPERLKTO:,VRPRWBRT=:VRPRWBRT:,VRPVERSDAT=:VRPVERSDAT:,VRPIBRT=:VRPIBRT:,VRPPRMENGE=:VRPPRMENGE:,VRPBERBASIS=:VRPBERBASIS:,VRPSTAFFEL=:VRPSTAFFEL:,VRPSTAFFME=:VRPSTAFFME:,VRPWERT=:VRPWERT:,VRPAUFMSL=:VRPAUFMSL:,VRPPACKTYP=:VRPPACKTYP:,VRPANFART=:VRPANFART:,VRPANFPROZ=:VRPANFPROZ:,VRPANFWERT=:VRPANFWERT:,VRPMRKMPROZ=:VRPMRKMPROZ:,VRPPOSTYP=:VRPPOSTYP:,VRPPOSBEZ=:VRPPOSBEZ:,VRPGRUPPE=:VRPGRUPPE:,VRPDRZUSCHL=:VRPDRZUSCHL:,VRPLFMENGE=:VRPLFMENGE:,VRPLFMENGET1=:VRPLFMENGET1:,VRPLFMENGET2=:VRPLFMENGET2:,VRPLFMENGET3=:VRPLFMENGET3:,VRPLFMENGET4=:VRPLFMENGET4:,VRPZUABWT1=:VRPZUABWT1:,VRPZUABMEEH1=:VRPZUABMEEH1:,VRPZUABWT2=:VRPZUABWT2:,VRPZUABMEEH2=:VRPZUABMEEH2:,VRPZUABWT3=:VRPZUABWT3:,VRPZUABMEEH3=:VRPZUABMEEH3:,VRPZUABWT4=:VRPZUABWT4:,VRPZUABMEEH4=:VRPZUABMEEH4:,VRPZUABWT5=:VRPZUABWT5:,VRPZUABMEEH5=:VRPZUABMEEH5:,VRPRABEB1=:VRPRABEB1:,VRPRABEB2=:VRPRABEB2:,VRPRABEB3=:VRPRABEB3:,VRPRABEB4=:VRPRABEB4:,VRPRABEB5=:VRPRABEB5:,VRPZUAEB1=:VRPZUAEB1:,VRPZUAEB2=:VRPZUAEB2:,VRPZUAEB3=:VRPZUAEB3:,VRPZUAEB4=:VRPZUAEB4:,VRPZUAEB5=:VRPZUAEB5:,VRPANZPROD=:VRPANZPROD:,VRPFIXBONP=:VRPFIXBONP:,VRPFIXBONA=:VRPFIXBONA:,VRPBONAEND=:VRPBONAEND:,VRPBONKZ=:VRPBONKZ:,VRPKSTTKZ=:VRPKSTTKZ:,VRPURAUFKRS=:VRPURAUFKRS:,VRPURAUFLFD=:VRPURAUFLFD:,VRPURAUFPOS=:VRPURAUFPOS:,VRPCOLORIT=:VRPCOLORIT:,VRPDESSIN=:VRPDESSIN:,VRPBESCHICH=:VRPBESCHICH:,VRPABPVAR=:VRPABPVAR:,VRPMINGRD=:VRPMINGRD:,VRPANLIEF=:VRPANLIEF:,VRPMEEHFB=:VRPMEEHFB:,VRPARTKUNDNR=:VRPARTKUNDNR:,VRPTERMNR=:VRPTERMNR:,VRPWAEHRSL=:VRPWAEHRSL:,VRPKURS=:VRPKURS:,VRPBETRAG=:VRPBETRAG:,VRPGROE=:VRPGROE:,VRPNRKR=:VRPNRKR:,VRPLFDNR=:VRPLFDNR:,VRPDATPRUEF=:VRPDATPRUEF:,VRPSTORNO=:VRPSTORNO:,VRPHWAEHRSL=:VRPHWAEHRSL:,VRPHEUROKURS=:VRPHEUROKURS:,VRPHEUROKURSVK=:VRPHEUROKURSVK:,VRPFEUROKURS=:VRPFEUROKURS:,VRPFEUROKURSVK=:VRPFEUROKURSVK:,VRPSTASCHL=:VRPSTASCHL:,VRPSTPROVP=:VRPSTPROVP:,VRPSTPROVAB=:VRPSTPROVAB:,VRPSTFRACHT=:VRPSTFRACHT:,VRPSTFRACHTAB=:VRPSTFRACHTAB:,VRPSTFRME=:VRPSTFRME:,VRPSTIMP=:VRPSTIMP:,VRPSTVERSP=:VRPSTVERSP:,VRPSTVERSAB=:VRPSTVERSAB:,VRPDUTY=:VRPDUTY:,VRPSTZOLLP=:VRPSTZOLLP:,VRPSTZOLLAB=:VRPSTZOLLAB:,VRPFOB=:VRPFOB:,VRPFRGR=:VRPFRGR:,VRPFRGRME=:VRPFRGRME:,VRPFRGRAB=:VRPFRGRAB:,VRPVERSGR=:VRPVERSGR:,VRPVERSGRAB=:VRPVERSGRAB:,VRPROHWERT=:VRPROHWERT:,VRPROHWERTAB=:VRPROHWERTAB:,VRPCOBORDER=:VRPCOBORDER:,VRPZOLLTNR=:VRPZOLLTNR:,VRPURLAND=:VRPURLAND:,VRPPRFBEG=:VRPPRFBEG:,VRPPRFSCHL=:VRPPRFSCHL:,VRPLGERKLNR=:VRPLGERKLNR:,VRPURZEUGKZ=:VRPURZEUGKZ:,VRPVERZKZ=:VRPVERZKZ:,VRPZOLAGER=:VRPZOLAGER:,VRPEZOLLTNR=:VRPEZOLLTNR:,VRPZFORMNR=:VRPZFORMNR:,VRPZFORMDAT=:VRPZFORMDAT:,VRPAVVME=:VRPAVVME:,VRPUEBKZ=:VRPUEBKZ:,VRPZOLLANM=:VRPZOLLANM:,VRPSTATIST=:VRPSTATIST:,VRPPRURLAND=:VRPPRURLAND:,VRPVGBETRAG=:VRPVGBETRAG:,VRPIPFRACHT=:VRPIPFRACHT:,VRPIPVERSICH=:VRPIPVERSICH:,VRPIPVERPKO=:VRPIPVERPKO:,VRPIPZOLL=:VRPIPZOLL:,VRPIPIMP=:VRPIPIMP:,VRPAELFDNRO=:VRPAELFDNRO:,VRPAELFDNRE=:VRPAELFDNRE:,VRPAEDATUM=:VRPAEDATUM:,VRPNEMENGE=:VRPNEMENGE:,VRPNEMENGET1=:VRPNEMENGET1:,VRPNEMENGET2=:VRPNEMENGET2:,VRPNEMENGET3=:VRPNEMENGET3:,VRPNEMENGET4=:VRPNEMENGET4:,VRPFAKMEKZ=:VRPFAKMEKZ:,VRPZUABKZ1=:VRPZUABKZ1:,VRPZUABKZ2=:VRPZUABKZ2:,VRPZUABKZ3=:VRPZUABKZ3:,VRPZUABKZ4=:VRPZUABKZ4:,VRPZUABKZ5=:VRPZUABKZ5:,VRPZUABMG1=:VRPZUABMG1:,VRPZUABMG2=:VRPZUABMG2:,VRPZUABMG3=:VRPZUABMG3:,VRPZUABMG4=:VRPZUABMG4:,VRPZUABMG5=:VRPZUABMG5:,VRPPROGRP=:VRPPROGRP:,VRPARTGRP=:VRPARTGRP:,VRPBUSIMODE=:VRPBUSIMODE:,VRPINTRA=:VRPINTRA:,VRPAPOSTYP=:VRPAPOSTYP:,VRPNIXVV=:VRPNIXVV:,VRPVERSLO=:VRPVERSLO:,VRPEMPLAND=:VRPEMPLAND:,VRPWOHER1=:VRPWOHER1:,VRPANTEIL1=:VRPANTEIL1:,VRPWOHER2=:VRPWOHER2:,VRPANTEIL2=:VRPANTEIL2:,VRPWOHER3=:VRPWOHER3:,VRPANTEIL3=:VRPANTEIL3:,VRPWOHER4=:VRPWOHER4:,VRPANTEIL4=:VRPANTEIL4:,VRPANTSUMME=:VRPANTSUMME:,VRPVRFM06=:VRPVRFM06:,VRPAFOLGE=:VRPAFOLGE:,VRPWEBER=:VRPWEBER:,VRPDRVERT=:VRPDRVERT:,VRPCBOOKNO=:VRPCBOOKNO:,VRPCITEMNO=:VRPCITEMNO:,VRPZUSTAND=:VRPZUSTAND:,VRPPACKANZ=:VRPPACKANZ:,VRPBRTGEW=:VRPBRTGEW:,VRPFILLER4=:VRPFILLER4:,VRPAENZL=:VRPAENZL:,VRPAENB=:VRPAENB:,VRPAEND=:VRPAEND:,VRPNEUB=:VRPNEUB:,VRPNEUD=:VRPNEUD:"
                        + " WHERE  VRPMANDANT=:VRPMANDANT: AND VRPRENR=:VRPRENR: AND VRPREPOS =:VRPREPOS: ";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        }

        public void UVRP03(DataRow dwData)
        {
            if (dwData != null)
            {
                dwData["VRPAENB"] = app.User;
                dwData["VRPAEND"] = date;
            }

            or1.CommandText = "UPDATE VRPOS SET VRPERLKZ=:VRPERLKZ:,VRPAENB=:VRPAENB:,VRPAEND=:VRPAEND:"
                + " WHERE  VRPMANDANT=:VRPMANDANT: AND VRPRENR=:VRPRENR: AND VRPREPOS =:VRPREPOS: ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData); 
            Connect2Proxy(or1);
        } 
    }
}
